/*
 * ExchRzTransNoticeExample.java
 * Copyright © 0000-9999 caoxy Technologies Inc.
 * All right reserved.
 * 奥里给
 */
package com.cxy.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ExchRzTransNoticeExample {
    /**
     * orderByClause 排序字段
     */
    protected String orderByClause;

    /**
     * distinct 是否过滤重复数据
     */
    protected boolean distinct;

    /**
     * oredCriteria 过滤条件实例
     */
    protected List<Criteria> oredCriteria;

    /**
     * 构造查询条件:EXCH_RZ_TRANS_NOTICE
     * 

     */
    public ExchRzTransNoticeExample() {
        oredCriteria = new ArrayList<>();
    }

    /**
     * 设置排序字段:EXCH_RZ_TRANS_NOTICE
     *
     * @param orderByClause 排序字段

     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序字段:EXCH_RZ_TRANS_NOTICE
     * 
     * @return String 排序规则
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置过滤重复数据:EXCH_RZ_TRANS_NOTICE
     *
     * @param distinct 是否过滤重复数据

     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否过滤重复数据:EXCH_RZ_TRANS_NOTICE
     * 
     * @return boolean 是否过滤重复
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获取当前的查询条件实例:EXCH_RZ_TRANS_NOTICE
     * 
     * @return List<Criteria> 获取标准集
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * 根据主键来更新符合条件的数据库记录:EXCH_RZ_TRANS_NOTICE
     *
     * @param criteria 过滤条件实例
     标准条件式
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * 根据主键来更新符合条件的数据库记录:EXCH_RZ_TRANS_NOTICE
     * 
     * @return Criteria 标准条件式
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建一个查询条件:EXCH_RZ_TRANS_NOTICE
     * 
     * @return Criteria 标准条件式
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 内部构建查询条件对象:EXCH_RZ_TRANS_NOTICE
     * 
     * @return Criteria 标准条件式
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除查询条件:EXCH_RZ_TRANS_NOTICE
     * 

     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * @Title EXCH_RZ_TRANS_NOTICE表的实体类
     * @description EXCH_RZ_TRANS_NOTICE
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andHostTrDateIsNull() {
            addCriterion("HOST_TR_DATE is null");
            return (Criteria) this;
        }

        public Criteria andHostTrDateIsNotNull() {
            addCriterion("HOST_TR_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andHostTrDateEqualTo(String value) {
            addCriterion("HOST_TR_DATE =", value, "hostTrDate");
            return (Criteria) this;
        }

        public Criteria andHostTrDateNotEqualTo(String value) {
            addCriterion("HOST_TR_DATE <>", value, "hostTrDate");
            return (Criteria) this;
        }

        public Criteria andHostTrDateGreaterThan(String value) {
            addCriterion("HOST_TR_DATE >", value, "hostTrDate");
            return (Criteria) this;
        }

        public Criteria andHostTrDateGreaterThanOrEqualTo(String value) {
            addCriterion("HOST_TR_DATE >=", value, "hostTrDate");
            return (Criteria) this;
        }

        public Criteria andHostTrDateLessThan(String value) {
            addCriterion("HOST_TR_DATE <", value, "hostTrDate");
            return (Criteria) this;
        }

        public Criteria andHostTrDateLessThanOrEqualTo(String value) {
            addCriterion("HOST_TR_DATE <=", value, "hostTrDate");
            return (Criteria) this;
        }

        public Criteria andHostTrDateLike(String value) {
            addCriterion("HOST_TR_DATE like", value, "hostTrDate");
            return (Criteria) this;
        }

        public Criteria andHostTrDateNotLike(String value) {
            addCriterion("HOST_TR_DATE not like", value, "hostTrDate");
            return (Criteria) this;
        }

        public Criteria andHostTrDateIn(List<String> values) {
            addCriterion("HOST_TR_DATE in", values, "hostTrDate");
            return (Criteria) this;
        }

        public Criteria andHostTrDateNotIn(List<String> values) {
            addCriterion("HOST_TR_DATE not in", values, "hostTrDate");
            return (Criteria) this;
        }

        public Criteria andHostTrDateBetween(String value1, String value2) {
            addCriterion("HOST_TR_DATE between", value1, value2, "hostTrDate");
            return (Criteria) this;
        }

        public Criteria andHostTrDateNotBetween(String value1, String value2) {
            addCriterion("HOST_TR_DATE not between", value1, value2, "hostTrDate");
            return (Criteria) this;
        }

        public Criteria andHostSerialNoIsNull() {
            addCriterion("HOST_SERIAL_NO is null");
            return (Criteria) this;
        }

        public Criteria andHostSerialNoIsNotNull() {
            addCriterion("HOST_SERIAL_NO is not null");
            return (Criteria) this;
        }

        public Criteria andHostSerialNoEqualTo(String value) {
            addCriterion("HOST_SERIAL_NO =", value, "hostSerialNo");
            return (Criteria) this;
        }

        public Criteria andHostSerialNoNotEqualTo(String value) {
            addCriterion("HOST_SERIAL_NO <>", value, "hostSerialNo");
            return (Criteria) this;
        }

        public Criteria andHostSerialNoGreaterThan(String value) {
            addCriterion("HOST_SERIAL_NO >", value, "hostSerialNo");
            return (Criteria) this;
        }

        public Criteria andHostSerialNoGreaterThanOrEqualTo(String value) {
            addCriterion("HOST_SERIAL_NO >=", value, "hostSerialNo");
            return (Criteria) this;
        }

        public Criteria andHostSerialNoLessThan(String value) {
            addCriterion("HOST_SERIAL_NO <", value, "hostSerialNo");
            return (Criteria) this;
        }

        public Criteria andHostSerialNoLessThanOrEqualTo(String value) {
            addCriterion("HOST_SERIAL_NO <=", value, "hostSerialNo");
            return (Criteria) this;
        }

        public Criteria andHostSerialNoLike(String value) {
            addCriterion("HOST_SERIAL_NO like", value, "hostSerialNo");
            return (Criteria) this;
        }

        public Criteria andHostSerialNoNotLike(String value) {
            addCriterion("HOST_SERIAL_NO not like", value, "hostSerialNo");
            return (Criteria) this;
        }

        public Criteria andHostSerialNoIn(List<String> values) {
            addCriterion("HOST_SERIAL_NO in", values, "hostSerialNo");
            return (Criteria) this;
        }

        public Criteria andHostSerialNoNotIn(List<String> values) {
            addCriterion("HOST_SERIAL_NO not in", values, "hostSerialNo");
            return (Criteria) this;
        }

        public Criteria andHostSerialNoBetween(String value1, String value2) {
            addCriterion("HOST_SERIAL_NO between", value1, value2, "hostSerialNo");
            return (Criteria) this;
        }

        public Criteria andHostSerialNoNotBetween(String value1, String value2) {
            addCriterion("HOST_SERIAL_NO not between", value1, value2, "hostSerialNo");
            return (Criteria) this;
        }

        public Criteria andCdFlagIsNull() {
            addCriterion("CD_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andCdFlagIsNotNull() {
            addCriterion("CD_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andCdFlagEqualTo(String value) {
            addCriterion("CD_FLAG =", value, "cdFlag");
            return (Criteria) this;
        }

        public Criteria andCdFlagNotEqualTo(String value) {
            addCriterion("CD_FLAG <>", value, "cdFlag");
            return (Criteria) this;
        }

        public Criteria andCdFlagGreaterThan(String value) {
            addCriterion("CD_FLAG >", value, "cdFlag");
            return (Criteria) this;
        }

        public Criteria andCdFlagGreaterThanOrEqualTo(String value) {
            addCriterion("CD_FLAG >=", value, "cdFlag");
            return (Criteria) this;
        }

        public Criteria andCdFlagLessThan(String value) {
            addCriterion("CD_FLAG <", value, "cdFlag");
            return (Criteria) this;
        }

        public Criteria andCdFlagLessThanOrEqualTo(String value) {
            addCriterion("CD_FLAG <=", value, "cdFlag");
            return (Criteria) this;
        }

        public Criteria andCdFlagLike(String value) {
            addCriterion("CD_FLAG like", value, "cdFlag");
            return (Criteria) this;
        }

        public Criteria andCdFlagNotLike(String value) {
            addCriterion("CD_FLAG not like", value, "cdFlag");
            return (Criteria) this;
        }

        public Criteria andCdFlagIn(List<String> values) {
            addCriterion("CD_FLAG in", values, "cdFlag");
            return (Criteria) this;
        }

        public Criteria andCdFlagNotIn(List<String> values) {
            addCriterion("CD_FLAG not in", values, "cdFlag");
            return (Criteria) this;
        }

        public Criteria andCdFlagBetween(String value1, String value2) {
            addCriterion("CD_FLAG between", value1, value2, "cdFlag");
            return (Criteria) this;
        }

        public Criteria andCdFlagNotBetween(String value1, String value2) {
            addCriterion("CD_FLAG not between", value1, value2, "cdFlag");
            return (Criteria) this;
        }

        public Criteria andTenantIdIsNull() {
            addCriterion("TENANT_ID is null");
            return (Criteria) this;
        }

        public Criteria andTenantIdIsNotNull() {
            addCriterion("TENANT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTenantIdEqualTo(String value) {
            addCriterion("TENANT_ID =", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotEqualTo(String value) {
            addCriterion("TENANT_ID <>", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdGreaterThan(String value) {
            addCriterion("TENANT_ID >", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdGreaterThanOrEqualTo(String value) {
            addCriterion("TENANT_ID >=", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLessThan(String value) {
            addCriterion("TENANT_ID <", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLessThanOrEqualTo(String value) {
            addCriterion("TENANT_ID <=", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLike(String value) {
            addCriterion("TENANT_ID like", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotLike(String value) {
            addCriterion("TENANT_ID not like", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdIn(List<String> values) {
            addCriterion("TENANT_ID in", values, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotIn(List<String> values) {
            addCriterion("TENANT_ID not in", values, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdBetween(String value1, String value2) {
            addCriterion("TENANT_ID between", value1, value2, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotBetween(String value1, String value2) {
            addCriterion("TENANT_ID not between", value1, value2, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTransDateIsNull() {
            addCriterion("TRANS_DATE is null");
            return (Criteria) this;
        }

        public Criteria andTransDateIsNotNull() {
            addCriterion("TRANS_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andTransDateEqualTo(String value) {
            addCriterion("TRANS_DATE =", value, "transDate");
            return (Criteria) this;
        }

        public Criteria andTransDateNotEqualTo(String value) {
            addCriterion("TRANS_DATE <>", value, "transDate");
            return (Criteria) this;
        }

        public Criteria andTransDateGreaterThan(String value) {
            addCriterion("TRANS_DATE >", value, "transDate");
            return (Criteria) this;
        }

        public Criteria andTransDateGreaterThanOrEqualTo(String value) {
            addCriterion("TRANS_DATE >=", value, "transDate");
            return (Criteria) this;
        }

        public Criteria andTransDateLessThan(String value) {
            addCriterion("TRANS_DATE <", value, "transDate");
            return (Criteria) this;
        }

        public Criteria andTransDateLessThanOrEqualTo(String value) {
            addCriterion("TRANS_DATE <=", value, "transDate");
            return (Criteria) this;
        }

        public Criteria andTransDateLike(String value) {
            addCriterion("TRANS_DATE like", value, "transDate");
            return (Criteria) this;
        }

        public Criteria andTransDateNotLike(String value) {
            addCriterion("TRANS_DATE not like", value, "transDate");
            return (Criteria) this;
        }

        public Criteria andTransDateIn(List<String> values) {
            addCriterion("TRANS_DATE in", values, "transDate");
            return (Criteria) this;
        }

        public Criteria andTransDateNotIn(List<String> values) {
            addCriterion("TRANS_DATE not in", values, "transDate");
            return (Criteria) this;
        }

        public Criteria andTransDateBetween(String value1, String value2) {
            addCriterion("TRANS_DATE between", value1, value2, "transDate");
            return (Criteria) this;
        }

        public Criteria andTransDateNotBetween(String value1, String value2) {
            addCriterion("TRANS_DATE not between", value1, value2, "transDate");
            return (Criteria) this;
        }

        public Criteria andSerialNoIsNull() {
            addCriterion("SERIAL_NO is null");
            return (Criteria) this;
        }

        public Criteria andSerialNoIsNotNull() {
            addCriterion("SERIAL_NO is not null");
            return (Criteria) this;
        }

        public Criteria andSerialNoEqualTo(String value) {
            addCriterion("SERIAL_NO =", value, "serialNo");
            return (Criteria) this;
        }

        public Criteria andSerialNoNotEqualTo(String value) {
            addCriterion("SERIAL_NO <>", value, "serialNo");
            return (Criteria) this;
        }

        public Criteria andSerialNoGreaterThan(String value) {
            addCriterion("SERIAL_NO >", value, "serialNo");
            return (Criteria) this;
        }

        public Criteria andSerialNoGreaterThanOrEqualTo(String value) {
            addCriterion("SERIAL_NO >=", value, "serialNo");
            return (Criteria) this;
        }

        public Criteria andSerialNoLessThan(String value) {
            addCriterion("SERIAL_NO <", value, "serialNo");
            return (Criteria) this;
        }

        public Criteria andSerialNoLessThanOrEqualTo(String value) {
            addCriterion("SERIAL_NO <=", value, "serialNo");
            return (Criteria) this;
        }

        public Criteria andSerialNoLike(String value) {
            addCriterion("SERIAL_NO like", value, "serialNo");
            return (Criteria) this;
        }

        public Criteria andSerialNoNotLike(String value) {
            addCriterion("SERIAL_NO not like", value, "serialNo");
            return (Criteria) this;
        }

        public Criteria andSerialNoIn(List<String> values) {
            addCriterion("SERIAL_NO in", values, "serialNo");
            return (Criteria) this;
        }

        public Criteria andSerialNoNotIn(List<String> values) {
            addCriterion("SERIAL_NO not in", values, "serialNo");
            return (Criteria) this;
        }

        public Criteria andSerialNoBetween(String value1, String value2) {
            addCriterion("SERIAL_NO between", value1, value2, "serialNo");
            return (Criteria) this;
        }

        public Criteria andSerialNoNotBetween(String value1, String value2) {
            addCriterion("SERIAL_NO not between", value1, value2, "serialNo");
            return (Criteria) this;
        }

        public Criteria andTrCodeIsNull() {
            addCriterion("TR_CODE is null");
            return (Criteria) this;
        }

        public Criteria andTrCodeIsNotNull() {
            addCriterion("TR_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andTrCodeEqualTo(String value) {
            addCriterion("TR_CODE =", value, "trCode");
            return (Criteria) this;
        }

        public Criteria andTrCodeNotEqualTo(String value) {
            addCriterion("TR_CODE <>", value, "trCode");
            return (Criteria) this;
        }

        public Criteria andTrCodeGreaterThan(String value) {
            addCriterion("TR_CODE >", value, "trCode");
            return (Criteria) this;
        }

        public Criteria andTrCodeGreaterThanOrEqualTo(String value) {
            addCriterion("TR_CODE >=", value, "trCode");
            return (Criteria) this;
        }

        public Criteria andTrCodeLessThan(String value) {
            addCriterion("TR_CODE <", value, "trCode");
            return (Criteria) this;
        }

        public Criteria andTrCodeLessThanOrEqualTo(String value) {
            addCriterion("TR_CODE <=", value, "trCode");
            return (Criteria) this;
        }

        public Criteria andTrCodeLike(String value) {
            addCriterion("TR_CODE like", value, "trCode");
            return (Criteria) this;
        }

        public Criteria andTrCodeNotLike(String value) {
            addCriterion("TR_CODE not like", value, "trCode");
            return (Criteria) this;
        }

        public Criteria andTrCodeIn(List<String> values) {
            addCriterion("TR_CODE in", values, "trCode");
            return (Criteria) this;
        }

        public Criteria andTrCodeNotIn(List<String> values) {
            addCriterion("TR_CODE not in", values, "trCode");
            return (Criteria) this;
        }

        public Criteria andTrCodeBetween(String value1, String value2) {
            addCriterion("TR_CODE between", value1, value2, "trCode");
            return (Criteria) this;
        }

        public Criteria andTrCodeNotBetween(String value1, String value2) {
            addCriterion("TR_CODE not between", value1, value2, "trCode");
            return (Criteria) this;
        }

        public Criteria andTransResultIsNull() {
            addCriterion("TRANS_RESULT is null");
            return (Criteria) this;
        }

        public Criteria andTransResultIsNotNull() {
            addCriterion("TRANS_RESULT is not null");
            return (Criteria) this;
        }

        public Criteria andTransResultEqualTo(String value) {
            addCriterion("TRANS_RESULT =", value, "transResult");
            return (Criteria) this;
        }

        public Criteria andTransResultNotEqualTo(String value) {
            addCriterion("TRANS_RESULT <>", value, "transResult");
            return (Criteria) this;
        }

        public Criteria andTransResultGreaterThan(String value) {
            addCriterion("TRANS_RESULT >", value, "transResult");
            return (Criteria) this;
        }

        public Criteria andTransResultGreaterThanOrEqualTo(String value) {
            addCriterion("TRANS_RESULT >=", value, "transResult");
            return (Criteria) this;
        }

        public Criteria andTransResultLessThan(String value) {
            addCriterion("TRANS_RESULT <", value, "transResult");
            return (Criteria) this;
        }

        public Criteria andTransResultLessThanOrEqualTo(String value) {
            addCriterion("TRANS_RESULT <=", value, "transResult");
            return (Criteria) this;
        }

        public Criteria andTransResultLike(String value) {
            addCriterion("TRANS_RESULT like", value, "transResult");
            return (Criteria) this;
        }

        public Criteria andTransResultNotLike(String value) {
            addCriterion("TRANS_RESULT not like", value, "transResult");
            return (Criteria) this;
        }

        public Criteria andTransResultIn(List<String> values) {
            addCriterion("TRANS_RESULT in", values, "transResult");
            return (Criteria) this;
        }

        public Criteria andTransResultNotIn(List<String> values) {
            addCriterion("TRANS_RESULT not in", values, "transResult");
            return (Criteria) this;
        }

        public Criteria andTransResultBetween(String value1, String value2) {
            addCriterion("TRANS_RESULT between", value1, value2, "transResult");
            return (Criteria) this;
        }

        public Criteria andTransResultNotBetween(String value1, String value2) {
            addCriterion("TRANS_RESULT not between", value1, value2, "transResult");
            return (Criteria) this;
        }

        public Criteria andNoticeTypeIsNull() {
            addCriterion("NOTICE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andNoticeTypeIsNotNull() {
            addCriterion("NOTICE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andNoticeTypeEqualTo(String value) {
            addCriterion("NOTICE_TYPE =", value, "noticeType");
            return (Criteria) this;
        }

        public Criteria andNoticeTypeNotEqualTo(String value) {
            addCriterion("NOTICE_TYPE <>", value, "noticeType");
            return (Criteria) this;
        }

        public Criteria andNoticeTypeGreaterThan(String value) {
            addCriterion("NOTICE_TYPE >", value, "noticeType");
            return (Criteria) this;
        }

        public Criteria andNoticeTypeGreaterThanOrEqualTo(String value) {
            addCriterion("NOTICE_TYPE >=", value, "noticeType");
            return (Criteria) this;
        }

        public Criteria andNoticeTypeLessThan(String value) {
            addCriterion("NOTICE_TYPE <", value, "noticeType");
            return (Criteria) this;
        }

        public Criteria andNoticeTypeLessThanOrEqualTo(String value) {
            addCriterion("NOTICE_TYPE <=", value, "noticeType");
            return (Criteria) this;
        }

        public Criteria andNoticeTypeLike(String value) {
            addCriterion("NOTICE_TYPE like", value, "noticeType");
            return (Criteria) this;
        }

        public Criteria andNoticeTypeNotLike(String value) {
            addCriterion("NOTICE_TYPE not like", value, "noticeType");
            return (Criteria) this;
        }

        public Criteria andNoticeTypeIn(List<String> values) {
            addCriterion("NOTICE_TYPE in", values, "noticeType");
            return (Criteria) this;
        }

        public Criteria andNoticeTypeNotIn(List<String> values) {
            addCriterion("NOTICE_TYPE not in", values, "noticeType");
            return (Criteria) this;
        }

        public Criteria andNoticeTypeBetween(String value1, String value2) {
            addCriterion("NOTICE_TYPE between", value1, value2, "noticeType");
            return (Criteria) this;
        }

        public Criteria andNoticeTypeNotBetween(String value1, String value2) {
            addCriterion("NOTICE_TYPE not between", value1, value2, "noticeType");
            return (Criteria) this;
        }

        public Criteria andMerAcctNoIsNull() {
            addCriterion("MER_ACCT_NO is null");
            return (Criteria) this;
        }

        public Criteria andMerAcctNoIsNotNull() {
            addCriterion("MER_ACCT_NO is not null");
            return (Criteria) this;
        }

        public Criteria andMerAcctNoEqualTo(String value) {
            addCriterion("MER_ACCT_NO =", value, "merAcctNo");
            return (Criteria) this;
        }

        public Criteria andMerAcctNoNotEqualTo(String value) {
            addCriterion("MER_ACCT_NO <>", value, "merAcctNo");
            return (Criteria) this;
        }

        public Criteria andMerAcctNoGreaterThan(String value) {
            addCriterion("MER_ACCT_NO >", value, "merAcctNo");
            return (Criteria) this;
        }

        public Criteria andMerAcctNoGreaterThanOrEqualTo(String value) {
            addCriterion("MER_ACCT_NO >=", value, "merAcctNo");
            return (Criteria) this;
        }

        public Criteria andMerAcctNoLessThan(String value) {
            addCriterion("MER_ACCT_NO <", value, "merAcctNo");
            return (Criteria) this;
        }

        public Criteria andMerAcctNoLessThanOrEqualTo(String value) {
            addCriterion("MER_ACCT_NO <=", value, "merAcctNo");
            return (Criteria) this;
        }

        public Criteria andMerAcctNoLike(String value) {
            addCriterion("MER_ACCT_NO like", value, "merAcctNo");
            return (Criteria) this;
        }

        public Criteria andMerAcctNoNotLike(String value) {
            addCriterion("MER_ACCT_NO not like", value, "merAcctNo");
            return (Criteria) this;
        }

        public Criteria andMerAcctNoIn(List<String> values) {
            addCriterion("MER_ACCT_NO in", values, "merAcctNo");
            return (Criteria) this;
        }

        public Criteria andMerAcctNoNotIn(List<String> values) {
            addCriterion("MER_ACCT_NO not in", values, "merAcctNo");
            return (Criteria) this;
        }

        public Criteria andMerAcctNoBetween(String value1, String value2) {
            addCriterion("MER_ACCT_NO between", value1, value2, "merAcctNo");
            return (Criteria) this;
        }

        public Criteria andMerAcctNoNotBetween(String value1, String value2) {
            addCriterion("MER_ACCT_NO not between", value1, value2, "merAcctNo");
            return (Criteria) this;
        }

        public Criteria andMerAcctNameIsNull() {
            addCriterion("MER_ACCT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andMerAcctNameIsNotNull() {
            addCriterion("MER_ACCT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andMerAcctNameEqualTo(String value) {
            addCriterion("MER_ACCT_NAME =", value, "merAcctName");
            return (Criteria) this;
        }

        public Criteria andMerAcctNameNotEqualTo(String value) {
            addCriterion("MER_ACCT_NAME <>", value, "merAcctName");
            return (Criteria) this;
        }

        public Criteria andMerAcctNameGreaterThan(String value) {
            addCriterion("MER_ACCT_NAME >", value, "merAcctName");
            return (Criteria) this;
        }

        public Criteria andMerAcctNameGreaterThanOrEqualTo(String value) {
            addCriterion("MER_ACCT_NAME >=", value, "merAcctName");
            return (Criteria) this;
        }

        public Criteria andMerAcctNameLessThan(String value) {
            addCriterion("MER_ACCT_NAME <", value, "merAcctName");
            return (Criteria) this;
        }

        public Criteria andMerAcctNameLessThanOrEqualTo(String value) {
            addCriterion("MER_ACCT_NAME <=", value, "merAcctName");
            return (Criteria) this;
        }

        public Criteria andMerAcctNameLike(String value) {
            addCriterion("MER_ACCT_NAME like", value, "merAcctName");
            return (Criteria) this;
        }

        public Criteria andMerAcctNameNotLike(String value) {
            addCriterion("MER_ACCT_NAME not like", value, "merAcctName");
            return (Criteria) this;
        }

        public Criteria andMerAcctNameIn(List<String> values) {
            addCriterion("MER_ACCT_NAME in", values, "merAcctName");
            return (Criteria) this;
        }

        public Criteria andMerAcctNameNotIn(List<String> values) {
            addCriterion("MER_ACCT_NAME not in", values, "merAcctName");
            return (Criteria) this;
        }

        public Criteria andMerAcctNameBetween(String value1, String value2) {
            addCriterion("MER_ACCT_NAME between", value1, value2, "merAcctName");
            return (Criteria) this;
        }

        public Criteria andMerAcctNameNotBetween(String value1, String value2) {
            addCriterion("MER_ACCT_NAME not between", value1, value2, "merAcctName");
            return (Criteria) this;
        }

        public Criteria andAcctBankNoIsNull() {
            addCriterion("ACCT_BANK_NO is null");
            return (Criteria) this;
        }

        public Criteria andAcctBankNoIsNotNull() {
            addCriterion("ACCT_BANK_NO is not null");
            return (Criteria) this;
        }

        public Criteria andAcctBankNoEqualTo(String value) {
            addCriterion("ACCT_BANK_NO =", value, "acctBankNo");
            return (Criteria) this;
        }

        public Criteria andAcctBankNoNotEqualTo(String value) {
            addCriterion("ACCT_BANK_NO <>", value, "acctBankNo");
            return (Criteria) this;
        }

        public Criteria andAcctBankNoGreaterThan(String value) {
            addCriterion("ACCT_BANK_NO >", value, "acctBankNo");
            return (Criteria) this;
        }

        public Criteria andAcctBankNoGreaterThanOrEqualTo(String value) {
            addCriterion("ACCT_BANK_NO >=", value, "acctBankNo");
            return (Criteria) this;
        }

        public Criteria andAcctBankNoLessThan(String value) {
            addCriterion("ACCT_BANK_NO <", value, "acctBankNo");
            return (Criteria) this;
        }

        public Criteria andAcctBankNoLessThanOrEqualTo(String value) {
            addCriterion("ACCT_BANK_NO <=", value, "acctBankNo");
            return (Criteria) this;
        }

        public Criteria andAcctBankNoLike(String value) {
            addCriterion("ACCT_BANK_NO like", value, "acctBankNo");
            return (Criteria) this;
        }

        public Criteria andAcctBankNoNotLike(String value) {
            addCriterion("ACCT_BANK_NO not like", value, "acctBankNo");
            return (Criteria) this;
        }

        public Criteria andAcctBankNoIn(List<String> values) {
            addCriterion("ACCT_BANK_NO in", values, "acctBankNo");
            return (Criteria) this;
        }

        public Criteria andAcctBankNoNotIn(List<String> values) {
            addCriterion("ACCT_BANK_NO not in", values, "acctBankNo");
            return (Criteria) this;
        }

        public Criteria andAcctBankNoBetween(String value1, String value2) {
            addCriterion("ACCT_BANK_NO between", value1, value2, "acctBankNo");
            return (Criteria) this;
        }

        public Criteria andAcctBankNoNotBetween(String value1, String value2) {
            addCriterion("ACCT_BANK_NO not between", value1, value2, "acctBankNo");
            return (Criteria) this;
        }

        public Criteria andAcctBankNameIsNull() {
            addCriterion("ACCT_BANK_NAME is null");
            return (Criteria) this;
        }

        public Criteria andAcctBankNameIsNotNull() {
            addCriterion("ACCT_BANK_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andAcctBankNameEqualTo(String value) {
            addCriterion("ACCT_BANK_NAME =", value, "acctBankName");
            return (Criteria) this;
        }

        public Criteria andAcctBankNameNotEqualTo(String value) {
            addCriterion("ACCT_BANK_NAME <>", value, "acctBankName");
            return (Criteria) this;
        }

        public Criteria andAcctBankNameGreaterThan(String value) {
            addCriterion("ACCT_BANK_NAME >", value, "acctBankName");
            return (Criteria) this;
        }

        public Criteria andAcctBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("ACCT_BANK_NAME >=", value, "acctBankName");
            return (Criteria) this;
        }

        public Criteria andAcctBankNameLessThan(String value) {
            addCriterion("ACCT_BANK_NAME <", value, "acctBankName");
            return (Criteria) this;
        }

        public Criteria andAcctBankNameLessThanOrEqualTo(String value) {
            addCriterion("ACCT_BANK_NAME <=", value, "acctBankName");
            return (Criteria) this;
        }

        public Criteria andAcctBankNameLike(String value) {
            addCriterion("ACCT_BANK_NAME like", value, "acctBankName");
            return (Criteria) this;
        }

        public Criteria andAcctBankNameNotLike(String value) {
            addCriterion("ACCT_BANK_NAME not like", value, "acctBankName");
            return (Criteria) this;
        }

        public Criteria andAcctBankNameIn(List<String> values) {
            addCriterion("ACCT_BANK_NAME in", values, "acctBankName");
            return (Criteria) this;
        }

        public Criteria andAcctBankNameNotIn(List<String> values) {
            addCriterion("ACCT_BANK_NAME not in", values, "acctBankName");
            return (Criteria) this;
        }

        public Criteria andAcctBankNameBetween(String value1, String value2) {
            addCriterion("ACCT_BANK_NAME between", value1, value2, "acctBankName");
            return (Criteria) this;
        }

        public Criteria andAcctBankNameNotBetween(String value1, String value2) {
            addCriterion("ACCT_BANK_NAME not between", value1, value2, "acctBankName");
            return (Criteria) this;
        }

        public Criteria andOppAcctNoIsNull() {
            addCriterion("OPP_ACCT_NO is null");
            return (Criteria) this;
        }

        public Criteria andOppAcctNoIsNotNull() {
            addCriterion("OPP_ACCT_NO is not null");
            return (Criteria) this;
        }

        public Criteria andOppAcctNoEqualTo(String value) {
            addCriterion("OPP_ACCT_NO =", value, "oppAcctNo");
            return (Criteria) this;
        }

        public Criteria andOppAcctNoNotEqualTo(String value) {
            addCriterion("OPP_ACCT_NO <>", value, "oppAcctNo");
            return (Criteria) this;
        }

        public Criteria andOppAcctNoGreaterThan(String value) {
            addCriterion("OPP_ACCT_NO >", value, "oppAcctNo");
            return (Criteria) this;
        }

        public Criteria andOppAcctNoGreaterThanOrEqualTo(String value) {
            addCriterion("OPP_ACCT_NO >=", value, "oppAcctNo");
            return (Criteria) this;
        }

        public Criteria andOppAcctNoLessThan(String value) {
            addCriterion("OPP_ACCT_NO <", value, "oppAcctNo");
            return (Criteria) this;
        }

        public Criteria andOppAcctNoLessThanOrEqualTo(String value) {
            addCriterion("OPP_ACCT_NO <=", value, "oppAcctNo");
            return (Criteria) this;
        }

        public Criteria andOppAcctNoLike(String value) {
            addCriterion("OPP_ACCT_NO like", value, "oppAcctNo");
            return (Criteria) this;
        }

        public Criteria andOppAcctNoNotLike(String value) {
            addCriterion("OPP_ACCT_NO not like", value, "oppAcctNo");
            return (Criteria) this;
        }

        public Criteria andOppAcctNoIn(List<String> values) {
            addCriterion("OPP_ACCT_NO in", values, "oppAcctNo");
            return (Criteria) this;
        }

        public Criteria andOppAcctNoNotIn(List<String> values) {
            addCriterion("OPP_ACCT_NO not in", values, "oppAcctNo");
            return (Criteria) this;
        }

        public Criteria andOppAcctNoBetween(String value1, String value2) {
            addCriterion("OPP_ACCT_NO between", value1, value2, "oppAcctNo");
            return (Criteria) this;
        }

        public Criteria andOppAcctNoNotBetween(String value1, String value2) {
            addCriterion("OPP_ACCT_NO not between", value1, value2, "oppAcctNo");
            return (Criteria) this;
        }

        public Criteria andOppAcctNameIsNull() {
            addCriterion("OPP_ACCT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andOppAcctNameIsNotNull() {
            addCriterion("OPP_ACCT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andOppAcctNameEqualTo(String value) {
            addCriterion("OPP_ACCT_NAME =", value, "oppAcctName");
            return (Criteria) this;
        }

        public Criteria andOppAcctNameNotEqualTo(String value) {
            addCriterion("OPP_ACCT_NAME <>", value, "oppAcctName");
            return (Criteria) this;
        }

        public Criteria andOppAcctNameGreaterThan(String value) {
            addCriterion("OPP_ACCT_NAME >", value, "oppAcctName");
            return (Criteria) this;
        }

        public Criteria andOppAcctNameGreaterThanOrEqualTo(String value) {
            addCriterion("OPP_ACCT_NAME >=", value, "oppAcctName");
            return (Criteria) this;
        }

        public Criteria andOppAcctNameLessThan(String value) {
            addCriterion("OPP_ACCT_NAME <", value, "oppAcctName");
            return (Criteria) this;
        }

        public Criteria andOppAcctNameLessThanOrEqualTo(String value) {
            addCriterion("OPP_ACCT_NAME <=", value, "oppAcctName");
            return (Criteria) this;
        }

        public Criteria andOppAcctNameLike(String value) {
            addCriterion("OPP_ACCT_NAME like", value, "oppAcctName");
            return (Criteria) this;
        }

        public Criteria andOppAcctNameNotLike(String value) {
            addCriterion("OPP_ACCT_NAME not like", value, "oppAcctName");
            return (Criteria) this;
        }

        public Criteria andOppAcctNameIn(List<String> values) {
            addCriterion("OPP_ACCT_NAME in", values, "oppAcctName");
            return (Criteria) this;
        }

        public Criteria andOppAcctNameNotIn(List<String> values) {
            addCriterion("OPP_ACCT_NAME not in", values, "oppAcctName");
            return (Criteria) this;
        }

        public Criteria andOppAcctNameBetween(String value1, String value2) {
            addCriterion("OPP_ACCT_NAME between", value1, value2, "oppAcctName");
            return (Criteria) this;
        }

        public Criteria andOppAcctNameNotBetween(String value1, String value2) {
            addCriterion("OPP_ACCT_NAME not between", value1, value2, "oppAcctName");
            return (Criteria) this;
        }

        public Criteria andOppBankNoIsNull() {
            addCriterion("OPP_BANK_NO is null");
            return (Criteria) this;
        }

        public Criteria andOppBankNoIsNotNull() {
            addCriterion("OPP_BANK_NO is not null");
            return (Criteria) this;
        }

        public Criteria andOppBankNoEqualTo(String value) {
            addCriterion("OPP_BANK_NO =", value, "oppBankNo");
            return (Criteria) this;
        }

        public Criteria andOppBankNoNotEqualTo(String value) {
            addCriterion("OPP_BANK_NO <>", value, "oppBankNo");
            return (Criteria) this;
        }

        public Criteria andOppBankNoGreaterThan(String value) {
            addCriterion("OPP_BANK_NO >", value, "oppBankNo");
            return (Criteria) this;
        }

        public Criteria andOppBankNoGreaterThanOrEqualTo(String value) {
            addCriterion("OPP_BANK_NO >=", value, "oppBankNo");
            return (Criteria) this;
        }

        public Criteria andOppBankNoLessThan(String value) {
            addCriterion("OPP_BANK_NO <", value, "oppBankNo");
            return (Criteria) this;
        }

        public Criteria andOppBankNoLessThanOrEqualTo(String value) {
            addCriterion("OPP_BANK_NO <=", value, "oppBankNo");
            return (Criteria) this;
        }

        public Criteria andOppBankNoLike(String value) {
            addCriterion("OPP_BANK_NO like", value, "oppBankNo");
            return (Criteria) this;
        }

        public Criteria andOppBankNoNotLike(String value) {
            addCriterion("OPP_BANK_NO not like", value, "oppBankNo");
            return (Criteria) this;
        }

        public Criteria andOppBankNoIn(List<String> values) {
            addCriterion("OPP_BANK_NO in", values, "oppBankNo");
            return (Criteria) this;
        }

        public Criteria andOppBankNoNotIn(List<String> values) {
            addCriterion("OPP_BANK_NO not in", values, "oppBankNo");
            return (Criteria) this;
        }

        public Criteria andOppBankNoBetween(String value1, String value2) {
            addCriterion("OPP_BANK_NO between", value1, value2, "oppBankNo");
            return (Criteria) this;
        }

        public Criteria andOppBankNoNotBetween(String value1, String value2) {
            addCriterion("OPP_BANK_NO not between", value1, value2, "oppBankNo");
            return (Criteria) this;
        }

        public Criteria andOppBankNameIsNull() {
            addCriterion("OPP_BANK_NAME is null");
            return (Criteria) this;
        }

        public Criteria andOppBankNameIsNotNull() {
            addCriterion("OPP_BANK_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andOppBankNameEqualTo(String value) {
            addCriterion("OPP_BANK_NAME =", value, "oppBankName");
            return (Criteria) this;
        }

        public Criteria andOppBankNameNotEqualTo(String value) {
            addCriterion("OPP_BANK_NAME <>", value, "oppBankName");
            return (Criteria) this;
        }

        public Criteria andOppBankNameGreaterThan(String value) {
            addCriterion("OPP_BANK_NAME >", value, "oppBankName");
            return (Criteria) this;
        }

        public Criteria andOppBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("OPP_BANK_NAME >=", value, "oppBankName");
            return (Criteria) this;
        }

        public Criteria andOppBankNameLessThan(String value) {
            addCriterion("OPP_BANK_NAME <", value, "oppBankName");
            return (Criteria) this;
        }

        public Criteria andOppBankNameLessThanOrEqualTo(String value) {
            addCriterion("OPP_BANK_NAME <=", value, "oppBankName");
            return (Criteria) this;
        }

        public Criteria andOppBankNameLike(String value) {
            addCriterion("OPP_BANK_NAME like", value, "oppBankName");
            return (Criteria) this;
        }

        public Criteria andOppBankNameNotLike(String value) {
            addCriterion("OPP_BANK_NAME not like", value, "oppBankName");
            return (Criteria) this;
        }

        public Criteria andOppBankNameIn(List<String> values) {
            addCriterion("OPP_BANK_NAME in", values, "oppBankName");
            return (Criteria) this;
        }

        public Criteria andOppBankNameNotIn(List<String> values) {
            addCriterion("OPP_BANK_NAME not in", values, "oppBankName");
            return (Criteria) this;
        }

        public Criteria andOppBankNameBetween(String value1, String value2) {
            addCriterion("OPP_BANK_NAME between", value1, value2, "oppBankName");
            return (Criteria) this;
        }

        public Criteria andOppBankNameNotBetween(String value1, String value2) {
            addCriterion("OPP_BANK_NAME not between", value1, value2, "oppBankName");
            return (Criteria) this;
        }

        public Criteria andOppBankAddrIsNull() {
            addCriterion("OPP_BANK_ADDR is null");
            return (Criteria) this;
        }

        public Criteria andOppBankAddrIsNotNull() {
            addCriterion("OPP_BANK_ADDR is not null");
            return (Criteria) this;
        }

        public Criteria andOppBankAddrEqualTo(String value) {
            addCriterion("OPP_BANK_ADDR =", value, "oppBankAddr");
            return (Criteria) this;
        }

        public Criteria andOppBankAddrNotEqualTo(String value) {
            addCriterion("OPP_BANK_ADDR <>", value, "oppBankAddr");
            return (Criteria) this;
        }

        public Criteria andOppBankAddrGreaterThan(String value) {
            addCriterion("OPP_BANK_ADDR >", value, "oppBankAddr");
            return (Criteria) this;
        }

        public Criteria andOppBankAddrGreaterThanOrEqualTo(String value) {
            addCriterion("OPP_BANK_ADDR >=", value, "oppBankAddr");
            return (Criteria) this;
        }

        public Criteria andOppBankAddrLessThan(String value) {
            addCriterion("OPP_BANK_ADDR <", value, "oppBankAddr");
            return (Criteria) this;
        }

        public Criteria andOppBankAddrLessThanOrEqualTo(String value) {
            addCriterion("OPP_BANK_ADDR <=", value, "oppBankAddr");
            return (Criteria) this;
        }

        public Criteria andOppBankAddrLike(String value) {
            addCriterion("OPP_BANK_ADDR like", value, "oppBankAddr");
            return (Criteria) this;
        }

        public Criteria andOppBankAddrNotLike(String value) {
            addCriterion("OPP_BANK_ADDR not like", value, "oppBankAddr");
            return (Criteria) this;
        }

        public Criteria andOppBankAddrIn(List<String> values) {
            addCriterion("OPP_BANK_ADDR in", values, "oppBankAddr");
            return (Criteria) this;
        }

        public Criteria andOppBankAddrNotIn(List<String> values) {
            addCriterion("OPP_BANK_ADDR not in", values, "oppBankAddr");
            return (Criteria) this;
        }

        public Criteria andOppBankAddrBetween(String value1, String value2) {
            addCriterion("OPP_BANK_ADDR between", value1, value2, "oppBankAddr");
            return (Criteria) this;
        }

        public Criteria andOppBankAddrNotBetween(String value1, String value2) {
            addCriterion("OPP_BANK_ADDR not between", value1, value2, "oppBankAddr");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNull() {
            addCriterion("CURRENCY is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNotNull() {
            addCriterion("CURRENCY is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyEqualTo(String value) {
            addCriterion("CURRENCY =", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotEqualTo(String value) {
            addCriterion("CURRENCY <>", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThan(String value) {
            addCriterion("CURRENCY >", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThanOrEqualTo(String value) {
            addCriterion("CURRENCY >=", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThan(String value) {
            addCriterion("CURRENCY <", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThanOrEqualTo(String value) {
            addCriterion("CURRENCY <=", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLike(String value) {
            addCriterion("CURRENCY like", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotLike(String value) {
            addCriterion("CURRENCY not like", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyIn(List<String> values) {
            addCriterion("CURRENCY in", values, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotIn(List<String> values) {
            addCriterion("CURRENCY not in", values, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyBetween(String value1, String value2) {
            addCriterion("CURRENCY between", value1, value2, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotBetween(String value1, String value2) {
            addCriterion("CURRENCY not between", value1, value2, "currency");
            return (Criteria) this;
        }

        public Criteria andTransAmtIsNull() {
            addCriterion("TRANS_AMT is null");
            return (Criteria) this;
        }

        public Criteria andTransAmtIsNotNull() {
            addCriterion("TRANS_AMT is not null");
            return (Criteria) this;
        }

        public Criteria andTransAmtEqualTo(BigDecimal value) {
            addCriterion("TRANS_AMT =", value, "transAmt");
            return (Criteria) this;
        }

        public Criteria andTransAmtNotEqualTo(BigDecimal value) {
            addCriterion("TRANS_AMT <>", value, "transAmt");
            return (Criteria) this;
        }

        public Criteria andTransAmtGreaterThan(BigDecimal value) {
            addCriterion("TRANS_AMT >", value, "transAmt");
            return (Criteria) this;
        }

        public Criteria andTransAmtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TRANS_AMT >=", value, "transAmt");
            return (Criteria) this;
        }

        public Criteria andTransAmtLessThan(BigDecimal value) {
            addCriterion("TRANS_AMT <", value, "transAmt");
            return (Criteria) this;
        }

        public Criteria andTransAmtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TRANS_AMT <=", value, "transAmt");
            return (Criteria) this;
        }

        public Criteria andTransAmtIn(List<BigDecimal> values) {
            addCriterion("TRANS_AMT in", values, "transAmt");
            return (Criteria) this;
        }

        public Criteria andTransAmtNotIn(List<BigDecimal> values) {
            addCriterion("TRANS_AMT not in", values, "transAmt");
            return (Criteria) this;
        }

        public Criteria andTransAmtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TRANS_AMT between", value1, value2, "transAmt");
            return (Criteria) this;
        }

        public Criteria andTransAmtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TRANS_AMT not between", value1, value2, "transAmt");
            return (Criteria) this;
        }

        public Criteria andRealBalanceIsNull() {
            addCriterion("REAL_BALANCE is null");
            return (Criteria) this;
        }

        public Criteria andRealBalanceIsNotNull() {
            addCriterion("REAL_BALANCE is not null");
            return (Criteria) this;
        }

        public Criteria andRealBalanceEqualTo(BigDecimal value) {
            addCriterion("REAL_BALANCE =", value, "realBalance");
            return (Criteria) this;
        }

        public Criteria andRealBalanceNotEqualTo(BigDecimal value) {
            addCriterion("REAL_BALANCE <>", value, "realBalance");
            return (Criteria) this;
        }

        public Criteria andRealBalanceGreaterThan(BigDecimal value) {
            addCriterion("REAL_BALANCE >", value, "realBalance");
            return (Criteria) this;
        }

        public Criteria andRealBalanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("REAL_BALANCE >=", value, "realBalance");
            return (Criteria) this;
        }

        public Criteria andRealBalanceLessThan(BigDecimal value) {
            addCriterion("REAL_BALANCE <", value, "realBalance");
            return (Criteria) this;
        }

        public Criteria andRealBalanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("REAL_BALANCE <=", value, "realBalance");
            return (Criteria) this;
        }

        public Criteria andRealBalanceIn(List<BigDecimal> values) {
            addCriterion("REAL_BALANCE in", values, "realBalance");
            return (Criteria) this;
        }

        public Criteria andRealBalanceNotIn(List<BigDecimal> values) {
            addCriterion("REAL_BALANCE not in", values, "realBalance");
            return (Criteria) this;
        }

        public Criteria andRealBalanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("REAL_BALANCE between", value1, value2, "realBalance");
            return (Criteria) this;
        }

        public Criteria andRealBalanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("REAL_BALANCE not between", value1, value2, "realBalance");
            return (Criteria) this;
        }

        public Criteria andUseBalanceIsNull() {
            addCriterion("USE_BALANCE is null");
            return (Criteria) this;
        }

        public Criteria andUseBalanceIsNotNull() {
            addCriterion("USE_BALANCE is not null");
            return (Criteria) this;
        }

        public Criteria andUseBalanceEqualTo(BigDecimal value) {
            addCriterion("USE_BALANCE =", value, "useBalance");
            return (Criteria) this;
        }

        public Criteria andUseBalanceNotEqualTo(BigDecimal value) {
            addCriterion("USE_BALANCE <>", value, "useBalance");
            return (Criteria) this;
        }

        public Criteria andUseBalanceGreaterThan(BigDecimal value) {
            addCriterion("USE_BALANCE >", value, "useBalance");
            return (Criteria) this;
        }

        public Criteria andUseBalanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("USE_BALANCE >=", value, "useBalance");
            return (Criteria) this;
        }

        public Criteria andUseBalanceLessThan(BigDecimal value) {
            addCriterion("USE_BALANCE <", value, "useBalance");
            return (Criteria) this;
        }

        public Criteria andUseBalanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("USE_BALANCE <=", value, "useBalance");
            return (Criteria) this;
        }

        public Criteria andUseBalanceIn(List<BigDecimal> values) {
            addCriterion("USE_BALANCE in", values, "useBalance");
            return (Criteria) this;
        }

        public Criteria andUseBalanceNotIn(List<BigDecimal> values) {
            addCriterion("USE_BALANCE not in", values, "useBalance");
            return (Criteria) this;
        }

        public Criteria andUseBalanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("USE_BALANCE between", value1, value2, "useBalance");
            return (Criteria) this;
        }

        public Criteria andUseBalanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("USE_BALANCE not between", value1, value2, "useBalance");
            return (Criteria) this;
        }

        public Criteria andMarginAmtIsNull() {
            addCriterion("MARGIN_AMT is null");
            return (Criteria) this;
        }

        public Criteria andMarginAmtIsNotNull() {
            addCriterion("MARGIN_AMT is not null");
            return (Criteria) this;
        }

        public Criteria andMarginAmtEqualTo(BigDecimal value) {
            addCriterion("MARGIN_AMT =", value, "marginAmt");
            return (Criteria) this;
        }

        public Criteria andMarginAmtNotEqualTo(BigDecimal value) {
            addCriterion("MARGIN_AMT <>", value, "marginAmt");
            return (Criteria) this;
        }

        public Criteria andMarginAmtGreaterThan(BigDecimal value) {
            addCriterion("MARGIN_AMT >", value, "marginAmt");
            return (Criteria) this;
        }

        public Criteria andMarginAmtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("MARGIN_AMT >=", value, "marginAmt");
            return (Criteria) this;
        }

        public Criteria andMarginAmtLessThan(BigDecimal value) {
            addCriterion("MARGIN_AMT <", value, "marginAmt");
            return (Criteria) this;
        }

        public Criteria andMarginAmtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("MARGIN_AMT <=", value, "marginAmt");
            return (Criteria) this;
        }

        public Criteria andMarginAmtIn(List<BigDecimal> values) {
            addCriterion("MARGIN_AMT in", values, "marginAmt");
            return (Criteria) this;
        }

        public Criteria andMarginAmtNotIn(List<BigDecimal> values) {
            addCriterion("MARGIN_AMT not in", values, "marginAmt");
            return (Criteria) this;
        }

        public Criteria andMarginAmtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MARGIN_AMT between", value1, value2, "marginAmt");
            return (Criteria) this;
        }

        public Criteria andMarginAmtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MARGIN_AMT not between", value1, value2, "marginAmt");
            return (Criteria) this;
        }

        public Criteria andMerNoIsNull() {
            addCriterion("MER_NO is null");
            return (Criteria) this;
        }

        public Criteria andMerNoIsNotNull() {
            addCriterion("MER_NO is not null");
            return (Criteria) this;
        }

        public Criteria andMerNoEqualTo(String value) {
            addCriterion("MER_NO =", value, "merNo");
            return (Criteria) this;
        }

        public Criteria andMerNoNotEqualTo(String value) {
            addCriterion("MER_NO <>", value, "merNo");
            return (Criteria) this;
        }

        public Criteria andMerNoGreaterThan(String value) {
            addCriterion("MER_NO >", value, "merNo");
            return (Criteria) this;
        }

        public Criteria andMerNoGreaterThanOrEqualTo(String value) {
            addCriterion("MER_NO >=", value, "merNo");
            return (Criteria) this;
        }

        public Criteria andMerNoLessThan(String value) {
            addCriterion("MER_NO <", value, "merNo");
            return (Criteria) this;
        }

        public Criteria andMerNoLessThanOrEqualTo(String value) {
            addCriterion("MER_NO <=", value, "merNo");
            return (Criteria) this;
        }

        public Criteria andMerNoLike(String value) {
            addCriterion("MER_NO like", value, "merNo");
            return (Criteria) this;
        }

        public Criteria andMerNoNotLike(String value) {
            addCriterion("MER_NO not like", value, "merNo");
            return (Criteria) this;
        }

        public Criteria andMerNoIn(List<String> values) {
            addCriterion("MER_NO in", values, "merNo");
            return (Criteria) this;
        }

        public Criteria andMerNoNotIn(List<String> values) {
            addCriterion("MER_NO not in", values, "merNo");
            return (Criteria) this;
        }

        public Criteria andMerNoBetween(String value1, String value2) {
            addCriterion("MER_NO between", value1, value2, "merNo");
            return (Criteria) this;
        }

        public Criteria andMerNoNotBetween(String value1, String value2) {
            addCriterion("MER_NO not between", value1, value2, "merNo");
            return (Criteria) this;
        }

        public Criteria andSubAcctNoIsNull() {
            addCriterion("SUB_ACCT_NO is null");
            return (Criteria) this;
        }

        public Criteria andSubAcctNoIsNotNull() {
            addCriterion("SUB_ACCT_NO is not null");
            return (Criteria) this;
        }

        public Criteria andSubAcctNoEqualTo(String value) {
            addCriterion("SUB_ACCT_NO =", value, "subAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubAcctNoNotEqualTo(String value) {
            addCriterion("SUB_ACCT_NO <>", value, "subAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubAcctNoGreaterThan(String value) {
            addCriterion("SUB_ACCT_NO >", value, "subAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubAcctNoGreaterThanOrEqualTo(String value) {
            addCriterion("SUB_ACCT_NO >=", value, "subAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubAcctNoLessThan(String value) {
            addCriterion("SUB_ACCT_NO <", value, "subAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubAcctNoLessThanOrEqualTo(String value) {
            addCriterion("SUB_ACCT_NO <=", value, "subAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubAcctNoLike(String value) {
            addCriterion("SUB_ACCT_NO like", value, "subAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubAcctNoNotLike(String value) {
            addCriterion("SUB_ACCT_NO not like", value, "subAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubAcctNoIn(List<String> values) {
            addCriterion("SUB_ACCT_NO in", values, "subAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubAcctNoNotIn(List<String> values) {
            addCriterion("SUB_ACCT_NO not in", values, "subAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubAcctNoBetween(String value1, String value2) {
            addCriterion("SUB_ACCT_NO between", value1, value2, "subAcctNo");
            return (Criteria) this;
        }

        public Criteria andSubAcctNoNotBetween(String value1, String value2) {
            addCriterion("SUB_ACCT_NO not between", value1, value2, "subAcctNo");
            return (Criteria) this;
        }

        public Criteria andCustNameIsNull() {
            addCriterion("CUST_NAME is null");
            return (Criteria) this;
        }

        public Criteria andCustNameIsNotNull() {
            addCriterion("CUST_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andCustNameEqualTo(String value) {
            addCriterion("CUST_NAME =", value, "custName");
            return (Criteria) this;
        }

        public Criteria andCustNameNotEqualTo(String value) {
            addCriterion("CUST_NAME <>", value, "custName");
            return (Criteria) this;
        }

        public Criteria andCustNameGreaterThan(String value) {
            addCriterion("CUST_NAME >", value, "custName");
            return (Criteria) this;
        }

        public Criteria andCustNameGreaterThanOrEqualTo(String value) {
            addCriterion("CUST_NAME >=", value, "custName");
            return (Criteria) this;
        }

        public Criteria andCustNameLessThan(String value) {
            addCriterion("CUST_NAME <", value, "custName");
            return (Criteria) this;
        }

        public Criteria andCustNameLessThanOrEqualTo(String value) {
            addCriterion("CUST_NAME <=", value, "custName");
            return (Criteria) this;
        }

        public Criteria andCustNameLike(String value) {
            addCriterion("CUST_NAME like", value, "custName");
            return (Criteria) this;
        }

        public Criteria andCustNameNotLike(String value) {
            addCriterion("CUST_NAME not like", value, "custName");
            return (Criteria) this;
        }

        public Criteria andCustNameIn(List<String> values) {
            addCriterion("CUST_NAME in", values, "custName");
            return (Criteria) this;
        }

        public Criteria andCustNameNotIn(List<String> values) {
            addCriterion("CUST_NAME not in", values, "custName");
            return (Criteria) this;
        }

        public Criteria andCustNameBetween(String value1, String value2) {
            addCriterion("CUST_NAME between", value1, value2, "custName");
            return (Criteria) this;
        }

        public Criteria andCustNameNotBetween(String value1, String value2) {
            addCriterion("CUST_NAME not between", value1, value2, "custName");
            return (Criteria) this;
        }

        public Criteria andTransTimeIsNull() {
            addCriterion("TRANS_TIME is null");
            return (Criteria) this;
        }

        public Criteria andTransTimeIsNotNull() {
            addCriterion("TRANS_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andTransTimeEqualTo(String value) {
            addCriterion("TRANS_TIME =", value, "transTime");
            return (Criteria) this;
        }

        public Criteria andTransTimeNotEqualTo(String value) {
            addCriterion("TRANS_TIME <>", value, "transTime");
            return (Criteria) this;
        }

        public Criteria andTransTimeGreaterThan(String value) {
            addCriterion("TRANS_TIME >", value, "transTime");
            return (Criteria) this;
        }

        public Criteria andTransTimeGreaterThanOrEqualTo(String value) {
            addCriterion("TRANS_TIME >=", value, "transTime");
            return (Criteria) this;
        }

        public Criteria andTransTimeLessThan(String value) {
            addCriterion("TRANS_TIME <", value, "transTime");
            return (Criteria) this;
        }

        public Criteria andTransTimeLessThanOrEqualTo(String value) {
            addCriterion("TRANS_TIME <=", value, "transTime");
            return (Criteria) this;
        }

        public Criteria andTransTimeLike(String value) {
            addCriterion("TRANS_TIME like", value, "transTime");
            return (Criteria) this;
        }

        public Criteria andTransTimeNotLike(String value) {
            addCriterion("TRANS_TIME not like", value, "transTime");
            return (Criteria) this;
        }

        public Criteria andTransTimeIn(List<String> values) {
            addCriterion("TRANS_TIME in", values, "transTime");
            return (Criteria) this;
        }

        public Criteria andTransTimeNotIn(List<String> values) {
            addCriterion("TRANS_TIME not in", values, "transTime");
            return (Criteria) this;
        }

        public Criteria andTransTimeBetween(String value1, String value2) {
            addCriterion("TRANS_TIME between", value1, value2, "transTime");
            return (Criteria) this;
        }

        public Criteria andTransTimeNotBetween(String value1, String value2) {
            addCriterion("TRANS_TIME not between", value1, value2, "transTime");
            return (Criteria) this;
        }

        public Criteria andSourceSideIsNull() {
            addCriterion("SOURCE_SIDE is null");
            return (Criteria) this;
        }

        public Criteria andSourceSideIsNotNull() {
            addCriterion("SOURCE_SIDE is not null");
            return (Criteria) this;
        }

        public Criteria andSourceSideEqualTo(String value) {
            addCriterion("SOURCE_SIDE =", value, "sourceSide");
            return (Criteria) this;
        }

        public Criteria andSourceSideNotEqualTo(String value) {
            addCriterion("SOURCE_SIDE <>", value, "sourceSide");
            return (Criteria) this;
        }

        public Criteria andSourceSideGreaterThan(String value) {
            addCriterion("SOURCE_SIDE >", value, "sourceSide");
            return (Criteria) this;
        }

        public Criteria andSourceSideGreaterThanOrEqualTo(String value) {
            addCriterion("SOURCE_SIDE >=", value, "sourceSide");
            return (Criteria) this;
        }

        public Criteria andSourceSideLessThan(String value) {
            addCriterion("SOURCE_SIDE <", value, "sourceSide");
            return (Criteria) this;
        }

        public Criteria andSourceSideLessThanOrEqualTo(String value) {
            addCriterion("SOURCE_SIDE <=", value, "sourceSide");
            return (Criteria) this;
        }

        public Criteria andSourceSideLike(String value) {
            addCriterion("SOURCE_SIDE like", value, "sourceSide");
            return (Criteria) this;
        }

        public Criteria andSourceSideNotLike(String value) {
            addCriterion("SOURCE_SIDE not like", value, "sourceSide");
            return (Criteria) this;
        }

        public Criteria andSourceSideIn(List<String> values) {
            addCriterion("SOURCE_SIDE in", values, "sourceSide");
            return (Criteria) this;
        }

        public Criteria andSourceSideNotIn(List<String> values) {
            addCriterion("SOURCE_SIDE not in", values, "sourceSide");
            return (Criteria) this;
        }

        public Criteria andSourceSideBetween(String value1, String value2) {
            addCriterion("SOURCE_SIDE between", value1, value2, "sourceSide");
            return (Criteria) this;
        }

        public Criteria andSourceSideNotBetween(String value1, String value2) {
            addCriterion("SOURCE_SIDE not between", value1, value2, "sourceSide");
            return (Criteria) this;
        }

        public Criteria andEntrustWayIsNull() {
            addCriterion("ENTRUST_WAY is null");
            return (Criteria) this;
        }

        public Criteria andEntrustWayIsNotNull() {
            addCriterion("ENTRUST_WAY is not null");
            return (Criteria) this;
        }

        public Criteria andEntrustWayEqualTo(String value) {
            addCriterion("ENTRUST_WAY =", value, "entrustWay");
            return (Criteria) this;
        }

        public Criteria andEntrustWayNotEqualTo(String value) {
            addCriterion("ENTRUST_WAY <>", value, "entrustWay");
            return (Criteria) this;
        }

        public Criteria andEntrustWayGreaterThan(String value) {
            addCriterion("ENTRUST_WAY >", value, "entrustWay");
            return (Criteria) this;
        }

        public Criteria andEntrustWayGreaterThanOrEqualTo(String value) {
            addCriterion("ENTRUST_WAY >=", value, "entrustWay");
            return (Criteria) this;
        }

        public Criteria andEntrustWayLessThan(String value) {
            addCriterion("ENTRUST_WAY <", value, "entrustWay");
            return (Criteria) this;
        }

        public Criteria andEntrustWayLessThanOrEqualTo(String value) {
            addCriterion("ENTRUST_WAY <=", value, "entrustWay");
            return (Criteria) this;
        }

        public Criteria andEntrustWayLike(String value) {
            addCriterion("ENTRUST_WAY like", value, "entrustWay");
            return (Criteria) this;
        }

        public Criteria andEntrustWayNotLike(String value) {
            addCriterion("ENTRUST_WAY not like", value, "entrustWay");
            return (Criteria) this;
        }

        public Criteria andEntrustWayIn(List<String> values) {
            addCriterion("ENTRUST_WAY in", values, "entrustWay");
            return (Criteria) this;
        }

        public Criteria andEntrustWayNotIn(List<String> values) {
            addCriterion("ENTRUST_WAY not in", values, "entrustWay");
            return (Criteria) this;
        }

        public Criteria andEntrustWayBetween(String value1, String value2) {
            addCriterion("ENTRUST_WAY between", value1, value2, "entrustWay");
            return (Criteria) this;
        }

        public Criteria andEntrustWayNotBetween(String value1, String value2) {
            addCriterion("ENTRUST_WAY not between", value1, value2, "entrustWay");
            return (Criteria) this;
        }

        public Criteria andOrgNoIsNull() {
            addCriterion("ORG_NO is null");
            return (Criteria) this;
        }

        public Criteria andOrgNoIsNotNull() {
            addCriterion("ORG_NO is not null");
            return (Criteria) this;
        }

        public Criteria andOrgNoEqualTo(String value) {
            addCriterion("ORG_NO =", value, "orgNo");
            return (Criteria) this;
        }

        public Criteria andOrgNoNotEqualTo(String value) {
            addCriterion("ORG_NO <>", value, "orgNo");
            return (Criteria) this;
        }

        public Criteria andOrgNoGreaterThan(String value) {
            addCriterion("ORG_NO >", value, "orgNo");
            return (Criteria) this;
        }

        public Criteria andOrgNoGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_NO >=", value, "orgNo");
            return (Criteria) this;
        }

        public Criteria andOrgNoLessThan(String value) {
            addCriterion("ORG_NO <", value, "orgNo");
            return (Criteria) this;
        }

        public Criteria andOrgNoLessThanOrEqualTo(String value) {
            addCriterion("ORG_NO <=", value, "orgNo");
            return (Criteria) this;
        }

        public Criteria andOrgNoLike(String value) {
            addCriterion("ORG_NO like", value, "orgNo");
            return (Criteria) this;
        }

        public Criteria andOrgNoNotLike(String value) {
            addCriterion("ORG_NO not like", value, "orgNo");
            return (Criteria) this;
        }

        public Criteria andOrgNoIn(List<String> values) {
            addCriterion("ORG_NO in", values, "orgNo");
            return (Criteria) this;
        }

        public Criteria andOrgNoNotIn(List<String> values) {
            addCriterion("ORG_NO not in", values, "orgNo");
            return (Criteria) this;
        }

        public Criteria andOrgNoBetween(String value1, String value2) {
            addCriterion("ORG_NO between", value1, value2, "orgNo");
            return (Criteria) this;
        }

        public Criteria andOrgNoNotBetween(String value1, String value2) {
            addCriterion("ORG_NO not between", value1, value2, "orgNo");
            return (Criteria) this;
        }

        public Criteria andOpCodeIsNull() {
            addCriterion("OP_CODE is null");
            return (Criteria) this;
        }

        public Criteria andOpCodeIsNotNull() {
            addCriterion("OP_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andOpCodeEqualTo(String value) {
            addCriterion("OP_CODE =", value, "opCode");
            return (Criteria) this;
        }

        public Criteria andOpCodeNotEqualTo(String value) {
            addCriterion("OP_CODE <>", value, "opCode");
            return (Criteria) this;
        }

        public Criteria andOpCodeGreaterThan(String value) {
            addCriterion("OP_CODE >", value, "opCode");
            return (Criteria) this;
        }

        public Criteria andOpCodeGreaterThanOrEqualTo(String value) {
            addCriterion("OP_CODE >=", value, "opCode");
            return (Criteria) this;
        }

        public Criteria andOpCodeLessThan(String value) {
            addCriterion("OP_CODE <", value, "opCode");
            return (Criteria) this;
        }

        public Criteria andOpCodeLessThanOrEqualTo(String value) {
            addCriterion("OP_CODE <=", value, "opCode");
            return (Criteria) this;
        }

        public Criteria andOpCodeLike(String value) {
            addCriterion("OP_CODE like", value, "opCode");
            return (Criteria) this;
        }

        public Criteria andOpCodeNotLike(String value) {
            addCriterion("OP_CODE not like", value, "opCode");
            return (Criteria) this;
        }

        public Criteria andOpCodeIn(List<String> values) {
            addCriterion("OP_CODE in", values, "opCode");
            return (Criteria) this;
        }

        public Criteria andOpCodeNotIn(List<String> values) {
            addCriterion("OP_CODE not in", values, "opCode");
            return (Criteria) this;
        }

        public Criteria andOpCodeBetween(String value1, String value2) {
            addCriterion("OP_CODE between", value1, value2, "opCode");
            return (Criteria) this;
        }

        public Criteria andOpCodeNotBetween(String value1, String value2) {
            addCriterion("OP_CODE not between", value1, value2, "opCode");
            return (Criteria) this;
        }

        public Criteria andAuthOpCodeIsNull() {
            addCriterion("AUTH_OP_CODE is null");
            return (Criteria) this;
        }

        public Criteria andAuthOpCodeIsNotNull() {
            addCriterion("AUTH_OP_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andAuthOpCodeEqualTo(String value) {
            addCriterion("AUTH_OP_CODE =", value, "authOpCode");
            return (Criteria) this;
        }

        public Criteria andAuthOpCodeNotEqualTo(String value) {
            addCriterion("AUTH_OP_CODE <>", value, "authOpCode");
            return (Criteria) this;
        }

        public Criteria andAuthOpCodeGreaterThan(String value) {
            addCriterion("AUTH_OP_CODE >", value, "authOpCode");
            return (Criteria) this;
        }

        public Criteria andAuthOpCodeGreaterThanOrEqualTo(String value) {
            addCriterion("AUTH_OP_CODE >=", value, "authOpCode");
            return (Criteria) this;
        }

        public Criteria andAuthOpCodeLessThan(String value) {
            addCriterion("AUTH_OP_CODE <", value, "authOpCode");
            return (Criteria) this;
        }

        public Criteria andAuthOpCodeLessThanOrEqualTo(String value) {
            addCriterion("AUTH_OP_CODE <=", value, "authOpCode");
            return (Criteria) this;
        }

        public Criteria andAuthOpCodeLike(String value) {
            addCriterion("AUTH_OP_CODE like", value, "authOpCode");
            return (Criteria) this;
        }

        public Criteria andAuthOpCodeNotLike(String value) {
            addCriterion("AUTH_OP_CODE not like", value, "authOpCode");
            return (Criteria) this;
        }

        public Criteria andAuthOpCodeIn(List<String> values) {
            addCriterion("AUTH_OP_CODE in", values, "authOpCode");
            return (Criteria) this;
        }

        public Criteria andAuthOpCodeNotIn(List<String> values) {
            addCriterion("AUTH_OP_CODE not in", values, "authOpCode");
            return (Criteria) this;
        }

        public Criteria andAuthOpCodeBetween(String value1, String value2) {
            addCriterion("AUTH_OP_CODE between", value1, value2, "authOpCode");
            return (Criteria) this;
        }

        public Criteria andAuthOpCodeNotBetween(String value1, String value2) {
            addCriterion("AUTH_OP_CODE not between", value1, value2, "authOpCode");
            return (Criteria) this;
        }

        public Criteria andTerminalNoIsNull() {
            addCriterion("TERMINAL_NO is null");
            return (Criteria) this;
        }

        public Criteria andTerminalNoIsNotNull() {
            addCriterion("TERMINAL_NO is not null");
            return (Criteria) this;
        }

        public Criteria andTerminalNoEqualTo(String value) {
            addCriterion("TERMINAL_NO =", value, "terminalNo");
            return (Criteria) this;
        }

        public Criteria andTerminalNoNotEqualTo(String value) {
            addCriterion("TERMINAL_NO <>", value, "terminalNo");
            return (Criteria) this;
        }

        public Criteria andTerminalNoGreaterThan(String value) {
            addCriterion("TERMINAL_NO >", value, "terminalNo");
            return (Criteria) this;
        }

        public Criteria andTerminalNoGreaterThanOrEqualTo(String value) {
            addCriterion("TERMINAL_NO >=", value, "terminalNo");
            return (Criteria) this;
        }

        public Criteria andTerminalNoLessThan(String value) {
            addCriterion("TERMINAL_NO <", value, "terminalNo");
            return (Criteria) this;
        }

        public Criteria andTerminalNoLessThanOrEqualTo(String value) {
            addCriterion("TERMINAL_NO <=", value, "terminalNo");
            return (Criteria) this;
        }

        public Criteria andTerminalNoLike(String value) {
            addCriterion("TERMINAL_NO like", value, "terminalNo");
            return (Criteria) this;
        }

        public Criteria andTerminalNoNotLike(String value) {
            addCriterion("TERMINAL_NO not like", value, "terminalNo");
            return (Criteria) this;
        }

        public Criteria andTerminalNoIn(List<String> values) {
            addCriterion("TERMINAL_NO in", values, "terminalNo");
            return (Criteria) this;
        }

        public Criteria andTerminalNoNotIn(List<String> values) {
            addCriterion("TERMINAL_NO not in", values, "terminalNo");
            return (Criteria) this;
        }

        public Criteria andTerminalNoBetween(String value1, String value2) {
            addCriterion("TERMINAL_NO between", value1, value2, "terminalNo");
            return (Criteria) this;
        }

        public Criteria andTerminalNoNotBetween(String value1, String value2) {
            addCriterion("TERMINAL_NO not between", value1, value2, "terminalNo");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("STATUS is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("STATUS =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("STATUS <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("STATUS >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("STATUS >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("STATUS <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("STATUS <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("STATUS like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("STATUS not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("STATUS in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("STATUS not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("STATUS between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("STATUS not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andAllotTypeIsNull() {
            addCriterion("ALLOT_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andAllotTypeIsNotNull() {
            addCriterion("ALLOT_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andAllotTypeEqualTo(String value) {
            addCriterion("ALLOT_TYPE =", value, "allotType");
            return (Criteria) this;
        }

        public Criteria andAllotTypeNotEqualTo(String value) {
            addCriterion("ALLOT_TYPE <>", value, "allotType");
            return (Criteria) this;
        }

        public Criteria andAllotTypeGreaterThan(String value) {
            addCriterion("ALLOT_TYPE >", value, "allotType");
            return (Criteria) this;
        }

        public Criteria andAllotTypeGreaterThanOrEqualTo(String value) {
            addCriterion("ALLOT_TYPE >=", value, "allotType");
            return (Criteria) this;
        }

        public Criteria andAllotTypeLessThan(String value) {
            addCriterion("ALLOT_TYPE <", value, "allotType");
            return (Criteria) this;
        }

        public Criteria andAllotTypeLessThanOrEqualTo(String value) {
            addCriterion("ALLOT_TYPE <=", value, "allotType");
            return (Criteria) this;
        }

        public Criteria andAllotTypeLike(String value) {
            addCriterion("ALLOT_TYPE like", value, "allotType");
            return (Criteria) this;
        }

        public Criteria andAllotTypeNotLike(String value) {
            addCriterion("ALLOT_TYPE not like", value, "allotType");
            return (Criteria) this;
        }

        public Criteria andAllotTypeIn(List<String> values) {
            addCriterion("ALLOT_TYPE in", values, "allotType");
            return (Criteria) this;
        }

        public Criteria andAllotTypeNotIn(List<String> values) {
            addCriterion("ALLOT_TYPE not in", values, "allotType");
            return (Criteria) this;
        }

        public Criteria andAllotTypeBetween(String value1, String value2) {
            addCriterion("ALLOT_TYPE between", value1, value2, "allotType");
            return (Criteria) this;
        }

        public Criteria andAllotTypeNotBetween(String value1, String value2) {
            addCriterion("ALLOT_TYPE not between", value1, value2, "allotType");
            return (Criteria) this;
        }

        public Criteria andErrorCodeIsNull() {
            addCriterion("ERROR_CODE is null");
            return (Criteria) this;
        }

        public Criteria andErrorCodeIsNotNull() {
            addCriterion("ERROR_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andErrorCodeEqualTo(String value) {
            addCriterion("ERROR_CODE =", value, "errorCode");
            return (Criteria) this;
        }

        public Criteria andErrorCodeNotEqualTo(String value) {
            addCriterion("ERROR_CODE <>", value, "errorCode");
            return (Criteria) this;
        }

        public Criteria andErrorCodeGreaterThan(String value) {
            addCriterion("ERROR_CODE >", value, "errorCode");
            return (Criteria) this;
        }

        public Criteria andErrorCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ERROR_CODE >=", value, "errorCode");
            return (Criteria) this;
        }

        public Criteria andErrorCodeLessThan(String value) {
            addCriterion("ERROR_CODE <", value, "errorCode");
            return (Criteria) this;
        }

        public Criteria andErrorCodeLessThanOrEqualTo(String value) {
            addCriterion("ERROR_CODE <=", value, "errorCode");
            return (Criteria) this;
        }

        public Criteria andErrorCodeLike(String value) {
            addCriterion("ERROR_CODE like", value, "errorCode");
            return (Criteria) this;
        }

        public Criteria andErrorCodeNotLike(String value) {
            addCriterion("ERROR_CODE not like", value, "errorCode");
            return (Criteria) this;
        }

        public Criteria andErrorCodeIn(List<String> values) {
            addCriterion("ERROR_CODE in", values, "errorCode");
            return (Criteria) this;
        }

        public Criteria andErrorCodeNotIn(List<String> values) {
            addCriterion("ERROR_CODE not in", values, "errorCode");
            return (Criteria) this;
        }

        public Criteria andErrorCodeBetween(String value1, String value2) {
            addCriterion("ERROR_CODE between", value1, value2, "errorCode");
            return (Criteria) this;
        }

        public Criteria andErrorCodeNotBetween(String value1, String value2) {
            addCriterion("ERROR_CODE not between", value1, value2, "errorCode");
            return (Criteria) this;
        }

        public Criteria andErrorMsgIsNull() {
            addCriterion("ERROR_MSG is null");
            return (Criteria) this;
        }

        public Criteria andErrorMsgIsNotNull() {
            addCriterion("ERROR_MSG is not null");
            return (Criteria) this;
        }

        public Criteria andErrorMsgEqualTo(String value) {
            addCriterion("ERROR_MSG =", value, "errorMsg");
            return (Criteria) this;
        }

        public Criteria andErrorMsgNotEqualTo(String value) {
            addCriterion("ERROR_MSG <>", value, "errorMsg");
            return (Criteria) this;
        }

        public Criteria andErrorMsgGreaterThan(String value) {
            addCriterion("ERROR_MSG >", value, "errorMsg");
            return (Criteria) this;
        }

        public Criteria andErrorMsgGreaterThanOrEqualTo(String value) {
            addCriterion("ERROR_MSG >=", value, "errorMsg");
            return (Criteria) this;
        }

        public Criteria andErrorMsgLessThan(String value) {
            addCriterion("ERROR_MSG <", value, "errorMsg");
            return (Criteria) this;
        }

        public Criteria andErrorMsgLessThanOrEqualTo(String value) {
            addCriterion("ERROR_MSG <=", value, "errorMsg");
            return (Criteria) this;
        }

        public Criteria andErrorMsgLike(String value) {
            addCriterion("ERROR_MSG like", value, "errorMsg");
            return (Criteria) this;
        }

        public Criteria andErrorMsgNotLike(String value) {
            addCriterion("ERROR_MSG not like", value, "errorMsg");
            return (Criteria) this;
        }

        public Criteria andErrorMsgIn(List<String> values) {
            addCriterion("ERROR_MSG in", values, "errorMsg");
            return (Criteria) this;
        }

        public Criteria andErrorMsgNotIn(List<String> values) {
            addCriterion("ERROR_MSG not in", values, "errorMsg");
            return (Criteria) this;
        }

        public Criteria andErrorMsgBetween(String value1, String value2) {
            addCriterion("ERROR_MSG between", value1, value2, "errorMsg");
            return (Criteria) this;
        }

        public Criteria andErrorMsgNotBetween(String value1, String value2) {
            addCriterion("ERROR_MSG not between", value1, value2, "errorMsg");
            return (Criteria) this;
        }

        public Criteria andBillInfoIsNull() {
            addCriterion("BILL_INFO is null");
            return (Criteria) this;
        }

        public Criteria andBillInfoIsNotNull() {
            addCriterion("BILL_INFO is not null");
            return (Criteria) this;
        }

        public Criteria andBillInfoEqualTo(String value) {
            addCriterion("BILL_INFO =", value, "billInfo");
            return (Criteria) this;
        }

        public Criteria andBillInfoNotEqualTo(String value) {
            addCriterion("BILL_INFO <>", value, "billInfo");
            return (Criteria) this;
        }

        public Criteria andBillInfoGreaterThan(String value) {
            addCriterion("BILL_INFO >", value, "billInfo");
            return (Criteria) this;
        }

        public Criteria andBillInfoGreaterThanOrEqualTo(String value) {
            addCriterion("BILL_INFO >=", value, "billInfo");
            return (Criteria) this;
        }

        public Criteria andBillInfoLessThan(String value) {
            addCriterion("BILL_INFO <", value, "billInfo");
            return (Criteria) this;
        }

        public Criteria andBillInfoLessThanOrEqualTo(String value) {
            addCriterion("BILL_INFO <=", value, "billInfo");
            return (Criteria) this;
        }

        public Criteria andBillInfoLike(String value) {
            addCriterion("BILL_INFO like", value, "billInfo");
            return (Criteria) this;
        }

        public Criteria andBillInfoNotLike(String value) {
            addCriterion("BILL_INFO not like", value, "billInfo");
            return (Criteria) this;
        }

        public Criteria andBillInfoIn(List<String> values) {
            addCriterion("BILL_INFO in", values, "billInfo");
            return (Criteria) this;
        }

        public Criteria andBillInfoNotIn(List<String> values) {
            addCriterion("BILL_INFO not in", values, "billInfo");
            return (Criteria) this;
        }

        public Criteria andBillInfoBetween(String value1, String value2) {
            addCriterion("BILL_INFO between", value1, value2, "billInfo");
            return (Criteria) this;
        }

        public Criteria andBillInfoNotBetween(String value1, String value2) {
            addCriterion("BILL_INFO not between", value1, value2, "billInfo");
            return (Criteria) this;
        }

        public Criteria andMerOrderNoIsNull() {
            addCriterion("MER_ORDER_NO is null");
            return (Criteria) this;
        }

        public Criteria andMerOrderNoIsNotNull() {
            addCriterion("MER_ORDER_NO is not null");
            return (Criteria) this;
        }

        public Criteria andMerOrderNoEqualTo(String value) {
            addCriterion("MER_ORDER_NO =", value, "merOrderNo");
            return (Criteria) this;
        }

        public Criteria andMerOrderNoNotEqualTo(String value) {
            addCriterion("MER_ORDER_NO <>", value, "merOrderNo");
            return (Criteria) this;
        }

        public Criteria andMerOrderNoGreaterThan(String value) {
            addCriterion("MER_ORDER_NO >", value, "merOrderNo");
            return (Criteria) this;
        }

        public Criteria andMerOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("MER_ORDER_NO >=", value, "merOrderNo");
            return (Criteria) this;
        }

        public Criteria andMerOrderNoLessThan(String value) {
            addCriterion("MER_ORDER_NO <", value, "merOrderNo");
            return (Criteria) this;
        }

        public Criteria andMerOrderNoLessThanOrEqualTo(String value) {
            addCriterion("MER_ORDER_NO <=", value, "merOrderNo");
            return (Criteria) this;
        }

        public Criteria andMerOrderNoLike(String value) {
            addCriterion("MER_ORDER_NO like", value, "merOrderNo");
            return (Criteria) this;
        }

        public Criteria andMerOrderNoNotLike(String value) {
            addCriterion("MER_ORDER_NO not like", value, "merOrderNo");
            return (Criteria) this;
        }

        public Criteria andMerOrderNoIn(List<String> values) {
            addCriterion("MER_ORDER_NO in", values, "merOrderNo");
            return (Criteria) this;
        }

        public Criteria andMerOrderNoNotIn(List<String> values) {
            addCriterion("MER_ORDER_NO not in", values, "merOrderNo");
            return (Criteria) this;
        }

        public Criteria andMerOrderNoBetween(String value1, String value2) {
            addCriterion("MER_ORDER_NO between", value1, value2, "merOrderNo");
            return (Criteria) this;
        }

        public Criteria andMerOrderNoNotBetween(String value1, String value2) {
            addCriterion("MER_ORDER_NO not between", value1, value2, "merOrderNo");
            return (Criteria) this;
        }

        public Criteria andBankOrderNoIsNull() {
            addCriterion("BANK_ORDER_NO is null");
            return (Criteria) this;
        }

        public Criteria andBankOrderNoIsNotNull() {
            addCriterion("BANK_ORDER_NO is not null");
            return (Criteria) this;
        }

        public Criteria andBankOrderNoEqualTo(String value) {
            addCriterion("BANK_ORDER_NO =", value, "bankOrderNo");
            return (Criteria) this;
        }

        public Criteria andBankOrderNoNotEqualTo(String value) {
            addCriterion("BANK_ORDER_NO <>", value, "bankOrderNo");
            return (Criteria) this;
        }

        public Criteria andBankOrderNoGreaterThan(String value) {
            addCriterion("BANK_ORDER_NO >", value, "bankOrderNo");
            return (Criteria) this;
        }

        public Criteria andBankOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("BANK_ORDER_NO >=", value, "bankOrderNo");
            return (Criteria) this;
        }

        public Criteria andBankOrderNoLessThan(String value) {
            addCriterion("BANK_ORDER_NO <", value, "bankOrderNo");
            return (Criteria) this;
        }

        public Criteria andBankOrderNoLessThanOrEqualTo(String value) {
            addCriterion("BANK_ORDER_NO <=", value, "bankOrderNo");
            return (Criteria) this;
        }

        public Criteria andBankOrderNoLike(String value) {
            addCriterion("BANK_ORDER_NO like", value, "bankOrderNo");
            return (Criteria) this;
        }

        public Criteria andBankOrderNoNotLike(String value) {
            addCriterion("BANK_ORDER_NO not like", value, "bankOrderNo");
            return (Criteria) this;
        }

        public Criteria andBankOrderNoIn(List<String> values) {
            addCriterion("BANK_ORDER_NO in", values, "bankOrderNo");
            return (Criteria) this;
        }

        public Criteria andBankOrderNoNotIn(List<String> values) {
            addCriterion("BANK_ORDER_NO not in", values, "bankOrderNo");
            return (Criteria) this;
        }

        public Criteria andBankOrderNoBetween(String value1, String value2) {
            addCriterion("BANK_ORDER_NO between", value1, value2, "bankOrderNo");
            return (Criteria) this;
        }

        public Criteria andBankOrderNoNotBetween(String value1, String value2) {
            addCriterion("BANK_ORDER_NO not between", value1, value2, "bankOrderNo");
            return (Criteria) this;
        }

        public Criteria andNoticeTimesIsNull() {
            addCriterion("NOTICE_TIMES is null");
            return (Criteria) this;
        }

        public Criteria andNoticeTimesIsNotNull() {
            addCriterion("NOTICE_TIMES is not null");
            return (Criteria) this;
        }

        public Criteria andNoticeTimesEqualTo(Integer value) {
            addCriterion("NOTICE_TIMES =", value, "noticeTimes");
            return (Criteria) this;
        }

        public Criteria andNoticeTimesNotEqualTo(Integer value) {
            addCriterion("NOTICE_TIMES <>", value, "noticeTimes");
            return (Criteria) this;
        }

        public Criteria andNoticeTimesGreaterThan(Integer value) {
            addCriterion("NOTICE_TIMES >", value, "noticeTimes");
            return (Criteria) this;
        }

        public Criteria andNoticeTimesGreaterThanOrEqualTo(Integer value) {
            addCriterion("NOTICE_TIMES >=", value, "noticeTimes");
            return (Criteria) this;
        }

        public Criteria andNoticeTimesLessThan(Integer value) {
            addCriterion("NOTICE_TIMES <", value, "noticeTimes");
            return (Criteria) this;
        }

        public Criteria andNoticeTimesLessThanOrEqualTo(Integer value) {
            addCriterion("NOTICE_TIMES <=", value, "noticeTimes");
            return (Criteria) this;
        }

        public Criteria andNoticeTimesIn(List<Integer> values) {
            addCriterion("NOTICE_TIMES in", values, "noticeTimes");
            return (Criteria) this;
        }

        public Criteria andNoticeTimesNotIn(List<Integer> values) {
            addCriterion("NOTICE_TIMES not in", values, "noticeTimes");
            return (Criteria) this;
        }

        public Criteria andNoticeTimesBetween(Integer value1, Integer value2) {
            addCriterion("NOTICE_TIMES between", value1, value2, "noticeTimes");
            return (Criteria) this;
        }

        public Criteria andNoticeTimesNotBetween(Integer value1, Integer value2) {
            addCriterion("NOTICE_TIMES not between", value1, value2, "noticeTimes");
            return (Criteria) this;
        }

        public Criteria andMerDateIsNull() {
            addCriterion("MER_DATE is null");
            return (Criteria) this;
        }

        public Criteria andMerDateIsNotNull() {
            addCriterion("MER_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andMerDateEqualTo(String value) {
            addCriterion("MER_DATE =", value, "merDate");
            return (Criteria) this;
        }

        public Criteria andMerDateNotEqualTo(String value) {
            addCriterion("MER_DATE <>", value, "merDate");
            return (Criteria) this;
        }

        public Criteria andMerDateGreaterThan(String value) {
            addCriterion("MER_DATE >", value, "merDate");
            return (Criteria) this;
        }

        public Criteria andMerDateGreaterThanOrEqualTo(String value) {
            addCriterion("MER_DATE >=", value, "merDate");
            return (Criteria) this;
        }

        public Criteria andMerDateLessThan(String value) {
            addCriterion("MER_DATE <", value, "merDate");
            return (Criteria) this;
        }

        public Criteria andMerDateLessThanOrEqualTo(String value) {
            addCriterion("MER_DATE <=", value, "merDate");
            return (Criteria) this;
        }

        public Criteria andMerDateLike(String value) {
            addCriterion("MER_DATE like", value, "merDate");
            return (Criteria) this;
        }

        public Criteria andMerDateNotLike(String value) {
            addCriterion("MER_DATE not like", value, "merDate");
            return (Criteria) this;
        }

        public Criteria andMerDateIn(List<String> values) {
            addCriterion("MER_DATE in", values, "merDate");
            return (Criteria) this;
        }

        public Criteria andMerDateNotIn(List<String> values) {
            addCriterion("MER_DATE not in", values, "merDate");
            return (Criteria) this;
        }

        public Criteria andMerDateBetween(String value1, String value2) {
            addCriterion("MER_DATE between", value1, value2, "merDate");
            return (Criteria) this;
        }

        public Criteria andMerDateNotBetween(String value1, String value2) {
            addCriterion("MER_DATE not between", value1, value2, "merDate");
            return (Criteria) this;
        }

        public Criteria andSummaryIsNull() {
            addCriterion("SUMMARY is null");
            return (Criteria) this;
        }

        public Criteria andSummaryIsNotNull() {
            addCriterion("SUMMARY is not null");
            return (Criteria) this;
        }

        public Criteria andSummaryEqualTo(String value) {
            addCriterion("SUMMARY =", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryNotEqualTo(String value) {
            addCriterion("SUMMARY <>", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryGreaterThan(String value) {
            addCriterion("SUMMARY >", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryGreaterThanOrEqualTo(String value) {
            addCriterion("SUMMARY >=", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryLessThan(String value) {
            addCriterion("SUMMARY <", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryLessThanOrEqualTo(String value) {
            addCriterion("SUMMARY <=", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryLike(String value) {
            addCriterion("SUMMARY like", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryNotLike(String value) {
            addCriterion("SUMMARY not like", value, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryIn(List<String> values) {
            addCriterion("SUMMARY in", values, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryNotIn(List<String> values) {
            addCriterion("SUMMARY not in", values, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryBetween(String value1, String value2) {
            addCriterion("SUMMARY between", value1, value2, "summary");
            return (Criteria) this;
        }

        public Criteria andSummaryNotBetween(String value1, String value2) {
            addCriterion("SUMMARY not between", value1, value2, "summary");
            return (Criteria) this;
        }

        public Criteria andCreDateIsNull() {
            addCriterion("CRE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreDateIsNotNull() {
            addCriterion("CRE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreDateEqualTo(Date value) {
            addCriterion("CRE_DATE =", value, "creDate");
            return (Criteria) this;
        }

        public Criteria andCreDateNotEqualTo(Date value) {
            addCriterion("CRE_DATE <>", value, "creDate");
            return (Criteria) this;
        }

        public Criteria andCreDateGreaterThan(Date value) {
            addCriterion("CRE_DATE >", value, "creDate");
            return (Criteria) this;
        }

        public Criteria andCreDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CRE_DATE >=", value, "creDate");
            return (Criteria) this;
        }

        public Criteria andCreDateLessThan(Date value) {
            addCriterion("CRE_DATE <", value, "creDate");
            return (Criteria) this;
        }

        public Criteria andCreDateLessThanOrEqualTo(Date value) {
            addCriterion("CRE_DATE <=", value, "creDate");
            return (Criteria) this;
        }

        public Criteria andCreDateIn(List<Date> values) {
            addCriterion("CRE_DATE in", values, "creDate");
            return (Criteria) this;
        }

        public Criteria andCreDateNotIn(List<Date> values) {
            addCriterion("CRE_DATE not in", values, "creDate");
            return (Criteria) this;
        }

        public Criteria andCreDateBetween(Date value1, Date value2) {
            addCriterion("CRE_DATE between", value1, value2, "creDate");
            return (Criteria) this;
        }

        public Criteria andCreDateNotBetween(Date value1, Date value2) {
            addCriterion("CRE_DATE not between", value1, value2, "creDate");
            return (Criteria) this;
        }

        public Criteria andUpdDateIsNull() {
            addCriterion("UPD_DATE is null");
            return (Criteria) this;
        }

        public Criteria andUpdDateIsNotNull() {
            addCriterion("UPD_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andUpdDateEqualTo(Date value) {
            addCriterion("UPD_DATE =", value, "updDate");
            return (Criteria) this;
        }

        public Criteria andUpdDateNotEqualTo(Date value) {
            addCriterion("UPD_DATE <>", value, "updDate");
            return (Criteria) this;
        }

        public Criteria andUpdDateGreaterThan(Date value) {
            addCriterion("UPD_DATE >", value, "updDate");
            return (Criteria) this;
        }

        public Criteria andUpdDateGreaterThanOrEqualTo(Date value) {
            addCriterion("UPD_DATE >=", value, "updDate");
            return (Criteria) this;
        }

        public Criteria andUpdDateLessThan(Date value) {
            addCriterion("UPD_DATE <", value, "updDate");
            return (Criteria) this;
        }

        public Criteria andUpdDateLessThanOrEqualTo(Date value) {
            addCriterion("UPD_DATE <=", value, "updDate");
            return (Criteria) this;
        }

        public Criteria andUpdDateIn(List<Date> values) {
            addCriterion("UPD_DATE in", values, "updDate");
            return (Criteria) this;
        }

        public Criteria andUpdDateNotIn(List<Date> values) {
            addCriterion("UPD_DATE not in", values, "updDate");
            return (Criteria) this;
        }

        public Criteria andUpdDateBetween(Date value1, Date value2) {
            addCriterion("UPD_DATE between", value1, value2, "updDate");
            return (Criteria) this;
        }

        public Criteria andUpdDateNotBetween(Date value1, Date value2) {
            addCriterion("UPD_DATE not between", value1, value2, "updDate");
            return (Criteria) this;
        }

        public Criteria andReserve1IsNull() {
            addCriterion("RESERVE1 is null");
            return (Criteria) this;
        }

        public Criteria andReserve1IsNotNull() {
            addCriterion("RESERVE1 is not null");
            return (Criteria) this;
        }

        public Criteria andReserve1EqualTo(String value) {
            addCriterion("RESERVE1 =", value, "reserve1");
            return (Criteria) this;
        }

        public Criteria andReserve1NotEqualTo(String value) {
            addCriterion("RESERVE1 <>", value, "reserve1");
            return (Criteria) this;
        }

        public Criteria andReserve1GreaterThan(String value) {
            addCriterion("RESERVE1 >", value, "reserve1");
            return (Criteria) this;
        }

        public Criteria andReserve1GreaterThanOrEqualTo(String value) {
            addCriterion("RESERVE1 >=", value, "reserve1");
            return (Criteria) this;
        }

        public Criteria andReserve1LessThan(String value) {
            addCriterion("RESERVE1 <", value, "reserve1");
            return (Criteria) this;
        }

        public Criteria andReserve1LessThanOrEqualTo(String value) {
            addCriterion("RESERVE1 <=", value, "reserve1");
            return (Criteria) this;
        }

        public Criteria andReserve1Like(String value) {
            addCriterion("RESERVE1 like", value, "reserve1");
            return (Criteria) this;
        }

        public Criteria andReserve1NotLike(String value) {
            addCriterion("RESERVE1 not like", value, "reserve1");
            return (Criteria) this;
        }

        public Criteria andReserve1In(List<String> values) {
            addCriterion("RESERVE1 in", values, "reserve1");
            return (Criteria) this;
        }

        public Criteria andReserve1NotIn(List<String> values) {
            addCriterion("RESERVE1 not in", values, "reserve1");
            return (Criteria) this;
        }

        public Criteria andReserve1Between(String value1, String value2) {
            addCriterion("RESERVE1 between", value1, value2, "reserve1");
            return (Criteria) this;
        }

        public Criteria andReserve1NotBetween(String value1, String value2) {
            addCriterion("RESERVE1 not between", value1, value2, "reserve1");
            return (Criteria) this;
        }

        public Criteria andReserve2IsNull() {
            addCriterion("RESERVE2 is null");
            return (Criteria) this;
        }

        public Criteria andReserve2IsNotNull() {
            addCriterion("RESERVE2 is not null");
            return (Criteria) this;
        }

        public Criteria andReserve2EqualTo(String value) {
            addCriterion("RESERVE2 =", value, "reserve2");
            return (Criteria) this;
        }

        public Criteria andReserve2NotEqualTo(String value) {
            addCriterion("RESERVE2 <>", value, "reserve2");
            return (Criteria) this;
        }

        public Criteria andReserve2GreaterThan(String value) {
            addCriterion("RESERVE2 >", value, "reserve2");
            return (Criteria) this;
        }

        public Criteria andReserve2GreaterThanOrEqualTo(String value) {
            addCriterion("RESERVE2 >=", value, "reserve2");
            return (Criteria) this;
        }

        public Criteria andReserve2LessThan(String value) {
            addCriterion("RESERVE2 <", value, "reserve2");
            return (Criteria) this;
        }

        public Criteria andReserve2LessThanOrEqualTo(String value) {
            addCriterion("RESERVE2 <=", value, "reserve2");
            return (Criteria) this;
        }

        public Criteria andReserve2Like(String value) {
            addCriterion("RESERVE2 like", value, "reserve2");
            return (Criteria) this;
        }

        public Criteria andReserve2NotLike(String value) {
            addCriterion("RESERVE2 not like", value, "reserve2");
            return (Criteria) this;
        }

        public Criteria andReserve2In(List<String> values) {
            addCriterion("RESERVE2 in", values, "reserve2");
            return (Criteria) this;
        }

        public Criteria andReserve2NotIn(List<String> values) {
            addCriterion("RESERVE2 not in", values, "reserve2");
            return (Criteria) this;
        }

        public Criteria andReserve2Between(String value1, String value2) {
            addCriterion("RESERVE2 between", value1, value2, "reserve2");
            return (Criteria) this;
        }

        public Criteria andReserve2NotBetween(String value1, String value2) {
            addCriterion("RESERVE2 not between", value1, value2, "reserve2");
            return (Criteria) this;
        }

        public Criteria andReserve3IsNull() {
            addCriterion("RESERVE3 is null");
            return (Criteria) this;
        }

        public Criteria andReserve3IsNotNull() {
            addCriterion("RESERVE3 is not null");
            return (Criteria) this;
        }

        public Criteria andReserve3EqualTo(String value) {
            addCriterion("RESERVE3 =", value, "reserve3");
            return (Criteria) this;
        }

        public Criteria andReserve3NotEqualTo(String value) {
            addCriterion("RESERVE3 <>", value, "reserve3");
            return (Criteria) this;
        }

        public Criteria andReserve3GreaterThan(String value) {
            addCriterion("RESERVE3 >", value, "reserve3");
            return (Criteria) this;
        }

        public Criteria andReserve3GreaterThanOrEqualTo(String value) {
            addCriterion("RESERVE3 >=", value, "reserve3");
            return (Criteria) this;
        }

        public Criteria andReserve3LessThan(String value) {
            addCriterion("RESERVE3 <", value, "reserve3");
            return (Criteria) this;
        }

        public Criteria andReserve3LessThanOrEqualTo(String value) {
            addCriterion("RESERVE3 <=", value, "reserve3");
            return (Criteria) this;
        }

        public Criteria andReserve3Like(String value) {
            addCriterion("RESERVE3 like", value, "reserve3");
            return (Criteria) this;
        }

        public Criteria andReserve3NotLike(String value) {
            addCriterion("RESERVE3 not like", value, "reserve3");
            return (Criteria) this;
        }

        public Criteria andReserve3In(List<String> values) {
            addCriterion("RESERVE3 in", values, "reserve3");
            return (Criteria) this;
        }

        public Criteria andReserve3NotIn(List<String> values) {
            addCriterion("RESERVE3 not in", values, "reserve3");
            return (Criteria) this;
        }

        public Criteria andReserve3Between(String value1, String value2) {
            addCriterion("RESERVE3 between", value1, value2, "reserve3");
            return (Criteria) this;
        }

        public Criteria andReserve3NotBetween(String value1, String value2) {
            addCriterion("RESERVE3 not between", value1, value2, "reserve3");
            return (Criteria) this;
        }
    }

    /**
     * @Title EXCH_RZ_TRANS_NOTICE表的实体类
     * @author caoxiaoyu31978
     * @date 2023-08-31 11:12:49
     * @description 记录融资通知信息,当银行向本系统发送动账通知时需要记录在此表,我方向交易所进行通讯时为轮询数据源表
     * <p>
     * 这是工具生成代码，禁止手工修改
     */
    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    /**
     * @Title EXCH_RZ_TRANS_NOTICE表的实体类
     * @description EXCH_RZ_TRANS_NOTICE
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}